﻿
GO
IF NOT EXISTS (SELECT Name FROM Resource WHERE Name = 'Physician' AND ApplicationId = 1)
BEGIN
INSERT INTO Resource(Name,ApplicationId,Uri)
     VALUES('Physician',1,'http://schemas.palisha.com/2012/10/identity/resources/physician')
END

GO
IF NOT EXISTS (SELECT Name FROM Resource WHERE Name = 'Patient' AND ApplicationId = 1)
BEGIN
INSERT INTO Resource(Name,ApplicationId,Uri)
     VALUES('Patient',1,'http://schemas.palisha.com/2012/10/identity/resources/patient')
END

GO
IF NOT EXISTS (SELECT Name FROM Resource WHERE Name = 'MainMenu' AND ApplicationId = 1)
BEGIN
INSERT INTO Resource(Name,ApplicationId,Uri)
     VALUES('MainMenu',1,'http://schemas.palisha.com/2012/10/identity/resources/mainmenu')
END
